﻿CREATE TABLE [dbo].[SystemUser] (
    [Id]             UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [Password]       NVARCHAR (500)   NOT NULL,
    [PasswordSalt]   NVARCHAR (500)   NOT NULL,
    [StaffId]        UNIQUEIDENTIFIER NULL,
    [PIN]            NVARCHAR (500)   NULL,
    [Active]         BIT              NOT NULL,
    [Locked]         BIT              NOT NULL,
    [LastIpAddress]  NVARCHAR (40)    NULL,
    [UserLoginCount] INT              NOT NULL,
    [LastLoginDate]  DATETIME         NULL,
    [Created]        DATETIME         NOT NULL,
    [Modified]       DATETIME         NOT NULL
);





